﻿CREATE PROCEDURE [dbo].[SaveJobOutput]
(@JobID varchar(50), @Xdoc text) as 
begin
	declare @existCount int
	set @existCount=(select count (*) from JobOutput where JobID=@JobID)
	if(@existCount>0)
	begin
		update JobOutput set Xdoc=@Xdoc where JobID=@JobID
	end
	else
	begin
		insert into JobOutput (JobID, Xdoc) values (@JobID, @Xdoc)
	end
end


